[dbo].[AVSBillingLog]

Property	Value
Created	10:08:09 AM Friday, January 27, 2012
Last Modified	11:40:00 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)	Default
AVSBillingLogKey	uniqueidentifier	16
IPIMISServer	nvarchar(15)	30
IPBrowser	nvarchar(15)	30
UserType	nvarchar(10)	20
VerificationType	nvarchar(10)	20
CountryCode	nchar(3)	6
iMISSerialNumber	nvarchar(255)	510
CreatedOn	datetime	8	(getdate())
UpdatedOn	datetime	8
IsSuccesfulTransaction	bit	1

	Name	Columns	Unique
	PK_AVSBillingLog	AVSBillingLogKey

SQL Script

CREATE TABLE [dbo].[AVSBillingLog]
(
[AVSBillingLogKey] [uniqueidentifier] NOT NULL,
[IPIMISServer] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IPBrowser] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UserType] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VerificationType] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CountryCode] [nchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[iMISSerialNumber] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedOn] [datetime] NULL CONSTRAINT [DF_AVSBillingLog_CreatedOn] DEFAULT (getdate()),
[UpdatedOn] [datetime] NULL,
[IsSuccesfulTransaction] [bit] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AVSBillingLog] ADD CONSTRAINT [PK_AVSBillingLog] PRIMARY KEY CLUSTERED ([AVSBillingLogKey]) ON [PRIMARY]
GO